/**
 * bu表操作 
 */
var MenuData = {
    // 按照班级关系查询学生数据
    queryCuData: function(param) {
        return "select * from user a left join bu b on a.ID = b.uid where b.bid = '"+param.cid+"';"; 
    },
    // 查询学生是否在班级
    queryCuBData: function(param) {
        return "select uid from bu where uid = '"+param.uid+"';"; 
    },
    // 删除ID对应的数据
    deleteData: function(param) {
        return "DELETE from bu where ID = " + param.id;
    },
    // 增加数据
    insertData: function(param) {
        return "INSERT INTO bu set bid = '"+param.bid+"' , uid = '"+ param.uid+"';";
    },
}
exports = module.exports = MenuData;